home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Libris Britannia 4
/
science library(b).zip
/
science library(b)
/
PROGRAMM
/
DB_CLIPP
/
0669.ZIP
/
DBTRANS.DOC
< prev
next >
Wrap
Text File
|
1986-11-10
|
3KB
|
65 lines
COPYRIGHT 1986 HENRY J. FRANZONI III, AND ARTHUR PERLEY
ALL RIGHTS RESERVED BY THE AUTHORS
NO COMMERCIAL USE PERMITTED WITHOUT EXPRESS WRITTEN CONSENT
OF THE AUTHORS...AUTHORS ADDRESS IS:
65 NASSAU ST. APT. 10C NEW YORK, NY 10038 (212)732-5473 (VOICE)
OR LEAVE MESSAGE ON THIS BOARD FOR HENRY FRANZONI
THIS PROGRAM IS RELEASED INTO THE PUBLIC DOMAIN
THIS PROGRAM NEEDS DBASE III + VERSION 1.1, AND PROCOMM VERSION 2.4
TO RUN. YOU NEED TWO COPIES OF EACH, ONE FOR THE NEAR END AND ONE FOR THE
FAR END. IN ADDITION, YOU NEED TWO MODEMS, PREFERABLY HAYES, AND TWO
PC'S WITH AT LEAST (640K ALTHOUGH 512K MAY WORK). THE TIME SHOULD BE SET
ON BOTH COMPUTERS, THEY SHOULD HAVE AT LEAST DOS 2.1 OR ABOVE, THEY
SHOULD HAVE HARD DISCS OR ENOUGH STORAGE FOR DBIII+ AND PROCOMM 2.4 AND
ALL DATA FILES
DBASE III+ IS A TRADEMARK OF ASHTON-TATE
PROCOMM 2.4 IS A TRADEMARK OF DATASTORM TECHNOLOGIES
THIS PROGRAM IS DESIGNED TO BEGIN TRANSFERING AT 11:59 MIDNIGHT
AND THEN SEND UPDATES BACK AND FORTH BETWEEN THE TWO FILES
NAMED "DATAFILE.DBF" WHICH ARE AT BOTH ENDS OF THE PHONE CONNECTION.
THIS CAN BE EASILY CHANGED TO SUIT INDIVIDUAL PREFERENCES
THE COMPUTER ON THE FAR END MUST RUN "GETREADY.PRG" BEFORE
THE NEAR END ATTEMPTS TRANSFER. THE FAR END COMPUTER WILL BE IN HOST MODE
IN PROCOMM, AND PROCOMM WILL BE RUNNING "UNDERNEATH" DBASE III +
RAM-RESIDENT PROGRAMS SHOULD BE REMOVED BEFORE THIS, PROBABLY, BECAUSE THE
COMBINATION OF PROCOMM 2.4 AND DBASE III + IS A MEMORY HOG
ON THE NEAR END, "DBTRANS.PRG" SHOULD BE RUNNING UNDER DBASE III +
AND IT WILL CALL PROCOMM WHILE RUNNING
THE PROGRAM DOES THE FOLLOWING FUNCTION(S):
THE FILE AT THE NEAR END IS USED, AND ALL OF THE RECORDS FOR WHICH
THERE IS A STATUS OF "NEW" ARE COPIED TO A TRANSFER FILE NAMED
"ONE_TWO.DBF", WHICH IS SENT AND APPENDED TO "DATAFILE.DBF" ON THE
REMOTE END. THE REMOTE COMPUTER SENDS BACK ALL OF THE RECORDS FOR WHICH
A STATUS OF "FILLED" EXISTS IN A FILE NAMED "TWO_ONE.DBF", FROM WHICH
INFORMATION IS TAKEN AND THE FILE "DATAFILE.DBF" ON THE NEAR END IS
UPDATED. THE RECORDS ARE NOT APPENDED ON THE NEAR END, THEY ARE UPDATED.
LIKEWISE, THE RECORDS ON THE FAR END ARE APPENDED ONLY, NOT UPDATED IF THEY
ALREADY EXIST.
THIS PROGRAM MAKES CERTAIN ASSUMPTIONS:
1). THAT PROCOMM 2.4 IS IN USE FOR BOTH ENDS OF THE CONNECTION.
2). THAT THE DATA DIRECTORY IS C:\DATA\.
3). THAT THE PASSWORD FOR THE HOST MODE IS "PASSWORD", AND THE PASSWORD FOR
THE SHELL AND REMOTE HOST CANCEL IS "EXITOUT".
4). THAT THE DATABASE UPDATED IS NAMED "DATAFILE.DBF" AT EACH END.
5). THAT THE TRANSFER FILES ARE NAMED "ONE_TWO.DBF" AND "TWO_ONE.DBF"
6). THAT A DBASE III + PROGRAM NAMED "GETREADY.PRG" HAS ALREADY BEEN RUN ON
THE ANSWERING END, ALONG WITH THE PROCOMM COMMAND FILE, "GETREADY.CMD".
7). ON THE CALLING END, A PROGRAM NAMED "DBTRANS.PRG" HAS CALLED THIS
PROCOMM COMMAND FILE NAMED "DBTRANS.CMD"
8). THE DIALING DIRECTORY ENTRY NUMBER 2 IS THE TELEPHONE NUMBER OF THE
OTHER COMPUTER IN BOTH PROCOMM 2.4 CONFIGURATIONS
9). LASTLY THAT THE DATABASE NAMED "DATAFILE" HAS FIELD NAMED "STATUS"
WHICH IS 7 CHARS LONG, AND A FIELD NAMED ORDER_NO WHICH IS 8 CHARS LONG
AND EACH ORDER_NO IS UNIQUE FOR EACH RECORD
*
P.S.
I HAVE HAD GREATER SUCCESS USING "NONE" AS THE HOST SETTING FOR
AUTO BAUD DETECT THAN "MODEM MSG" OR "KEY HIT".